CBSE Class 12 Computer Science (083) – 2025–2026 Syllabus Units
- Unit 1: Python Revision & Functions
- Unit 2: File Handling
- Unit 3: Using Python Libraries
- Unit 4: Data Structures (Stack, Queue)
- Unit 5: Computer Networks & Web Development
- Unit 6: Database Concepts & SQL
- Unit 7: Interface Python with SQL
- Unit 8: Introduction to Computer Systems
- Unit 9: Data Communication & Security
- Unit 10: Society, Law & Ethics
Priority Ranking – Most Important Units (Based on 2021–2025 PYQs)
| Priority | Unit / Chapter | Expected Marks | Most Repeated Question Types |
|---|---|---|---|
| 1 | Database Concepts & SQL | 10–15 marks | SQL queries (SELECT, JOIN, GROUP BY, HAVING, subquery), DDL, DML, keys, normalization |
| 2 | Interface Python with SQL | 8–12 marks | Python + MySQL connectivity, fetchall(), execute(), commit(), parameterized queries |
| 3 | Data Structures (Stack & Queue) | 6–10 marks | Implementation using list/class, push/pop, enqueue/dequeue, applications |
| 4 | File Handling | 6–8 marks | Text & binary file operations, read/write, seek(), tell(), CSV handling |
| 5 | Computer Networks & Web Development | 5–8 marks | Network devices, topologies, HTTP/HTTPS, HTML tags, CSS basics |
| 6 | Using Python Libraries | 4–6 marks | Random, math, statistics modules, pandas/numpy basics |
Unit-wise Important Questions & Keywords
1. Database Concepts & SQL
- Most Repeated Questions (10–15 marks)
- Write SQL queries to create table, insert, update, delete, select with WHERE, ORDER BY, GROUP BY, HAVING
- Find second highest salary, count employees per department, join tables (INNER, LEFT, RIGHT)
- Difference between PRIMARY KEY & UNIQUE, DDL vs DML, normalization (1NF, 2NF, 3NF)
- Important Keywords: DDL, DML, DQL, primary key, foreign key, candidate key, super key, normalization, aggregate functions (COUNT, SUM, AVG, MAX, MIN), JOIN, subquery, alias, DISTINCT
2. Interface Python with SQL
- Most Repeated Questions (8–12 marks)
- Write Python code to connect to MySQL, create table, insert multiple records, fetch data using fetchall()/fetchone()
- Parameterized query to avoid SQL injection, commit & rollback
- Display records in tabular format using print
- Important Keywords: mysql.connector, connect(), cursor(), execute(), commit(), fetchall(), fetchone(), close(), parameterized query (%s), error handling
3. Data Structures – Stack & Queue
- Most Repeated Questions (6–10 marks)
- Implement Stack using list/class with push, pop, peek, is_empty operations
- Implement Queue using list/class with enqueue, dequeue, front, rear
- Applications of stack (expression evaluation, undo) & queue (printer queue, BFS)
- Important Keywords: LIFO, FIFO, push, pop, enqueue, dequeue, peek, front, rear, overflow, underflow, dynamic stack/queue
Exam Strategy – Computer Science (2026 Boards)
- Most repeated units: SQL (10–15 marks), Python-SQL connectivity (8–12 marks), Stack/Queue (6–10 marks)
- SQL questions: Always write exact syntax, use proper indentation, mention table names & column names
- Python code: Use meaningful variable names, comment 2–3 lines, handle exceptions if asked
- Time management: 15–18 minutes for 10–12 mark SQL/Python questions
- Practice tip: Solve last 5 years papers + sample papers 2025–26, focus on output-based & error-finding questions
This guide covers the complete Class 12 Computer Science syllabus as per 2025–2026 CBSE guidelines.